﻿using System;
using System.Collections.Generic;
using System.Text;
using CeA.Reports.Atendimento.DataAccess.DTO;
using System.Data.OracleClient;
using System.Data;
using CeA.Reports.Atendimento.DataAccess.Helpers;
using CeA.Reports.Atendimento.DataAccess.Criteria;
using IBatisNet.DataMapper;

namespace CeA.Reports.Atendimento.DataAccess.DAO.Oracle {
    public class OracleHoraImpl : Hora {
        

        public OracleHoraImpl() {
            // m_connection = OracleDAOFactory.CreateConnection();
        }

        /// <summary>
        /// Lista as Hora com critério de busca.
        /// </summary>
        /// <returns></returns>
        public List<HoraDTO> ListarIdentificacao() {
            IList<HoraDTO> list = Mapper.Instance()
                   .QueryForList<HoraDTO>("horaSelectList", null);
            return (List<HoraDTO>)list;
        }

        public HoraDTO Recuperar(int id)
        {
            HoraDTO dto = Mapper.Instance().QueryForObject<HoraDTO>("selectHora", id);
            return dto;
        }

    }
}
